# 读取excel
import  pandas as pd
df = pd.read_excel("./movieinfo.xlsx")
print(df.info())
# 删除缺失项数据
df = df.dropna()
print(df.info())
df.to_excel("./movieinfo.xlsx",index=False)

